PM Payment Apply To Work File (PM10201)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Payment Apply To Work File (PM10201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM10201

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Payment Apply To Work File
Physical Name: PM10201
Technical Name: PM_Payment_Apply_WORK

Group Display Name: Payables Transaction Logical File
Group Technical Name: PM_Transaction_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	DiscTknTot	Discount Taken Total	Currency	DLR19_RBS0_STR$	19
2	NetCkAmt	Net Check Amount	Currency	DLR17_RBS0_STR$	17
3	PdTot	Paid Total	Currency	DLR17_RBS0_STR$	17
4	NegTot	Negative Total	Currency	DLR17_RBS0_STR$	17
5	CrdDocAmt	Credit Document Amount	Currency	DLR19_$S2	19
6	TotDocAmt	Total Document Amount	Currency	DLR19_RBS0_STR$	19
7	WrOffTot	Write Off Total	Currency	DLR19_RBS0_UTR$	19
8	CrdtDesc	Credit Description	String	STR30	30
9	TRXDSCRN	Transaction Description	String	STR30	30
10	PrtOnStb	Print On Stub	Boolean	Boolean	0
11	PMNTNMBR	Payment Number	String	STR20_LBAU	20
12	KEYFIELD	Key Field	String	STR20	20
13	APFVCHNM	Apply From Voucher Number	String	STR20_LBAU	20
14	APTVCHNM	Apply To Voucher Number	String	STR20_LBAU	20
15	APFRDCTY	Apply From Document Type	Integer	INT2	2
16	APTODCTY	Apply To Document Type	Integer	DDL_Document_Type	0
17	DOCNUMBR	Document Number	String	STR20_Document_Number	20
18	DOCDATE	Document Date	Date	DT	8
19	AMNTPAID	Amount Paid	Currency	DLR17_RBS0_STR$	17
20	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19
21	DocDueDate	Document Due Date	Date	DATE	6
22	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
23	DISCDATE	Discount Date	Date	DT	8
24	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
25	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
26	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
27	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
28	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PM Payment Apply To Work File'].CURNCYID AS 'PM Payment Apply To Work File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PM10201 AS ['PM Payment Apply To Work File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PM Payment Apply To Work File'].CURNCYID = ['Currency Setup'].CURNCYID
29	Outstanding_Amount	Outstanding Amount	Currency	DLR19_RBS0_UTR$	19
30	Net_Paid_Amount	Net Paid Amount	Currency	DLR19_RBS0_UTR$	19
31	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['PM Payment Apply To Work File'].VCHRNMBR AS 'PM Payment Apply To Work File-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM PM10201 AS ['PM Payment Apply To Work File'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['PM Payment Apply To Work File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['PM Payment Apply To Work File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
32	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
	Click to show/hide Document Types 1 Invoice 2 Finance Charge 3 Miscellaneous Charges 4 Return 5 Credit Memo
33	Selected_To_Print	Selected To Print	Boolean	CB	0
34	PONUMBER	PO Number	String	STR17_POP_Number	17

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Payment Apply To Work File (PM10201)

Click to show/hide

Click to show/hide

Click to show/hide Document Types

Leave a Reply Cancel reply